What is the syntax of creating global temporary tables?

  1. Home
  2. Back

Question:
What is the syntax of creating global temporary tables?

1.CREATE GLOBAL TEMPORARY TABLE

2.CREATE LOCAL TEMPORARY TABLE

3.CREATE TEMPORARY TABLE

4.None

Posted Date:-2022-11-15 07:18:41

More MCQS Questions and answers

  1. In addition to eliminating all ____ integrity constraints, CASCADE CONSTRAINTS will also drop all other constraints.
  2. What does the table_name in syntax specifies?
  3. What is the statement to modify the column in the table?
  4. What is the syntax of CREATE TABLE AS?
  5. A new table is created in an Oracle database using the ____ TABLE statement.
  6. A new table will contain records from the ___ table if it is created using the CREATE TABLE AS method.
  7. ALTER TABLE is also used to ____ the table.
  8. Around 20 different _____ protocols and over 100 different hardware platforms are supported by this database.
  9. Backups can be performed ____ with RMAN.
  10. By copying the columns of an existing table, the CREATE TABLE __ statement creates a new table based on an existing table.
  11. By using the RMAN (_____ Manager) functionality of the Oracle database, it is very easy to recover quickly.
  12. For ____ programming, PL/SQL extension support is one of the biggest benefits of Oracle databases.
  13. It is possible to manage services across multiple instances using ____ together.
  14. Multiple database instances can be managed on ____ server with Oracle database.
  15. Oracle will ____ the table if there is a referential integrity constraint on table_name that is not specified as CASCADE CONSTRAINTS on the DROP TABLE statement.
  16. Oracle's database can be ____ from one platform to another compared to other competitors.
  17. Oracle's temporary tables are local to the ____ in which they are created and cannot be accessed outside of that ____.
  18. Primary keys can only be found in ____ table at a time.
  19. SQL* ____ can also be used for recovery, which is also known as user-managed recovery.
  20. Tables are created by _____ types for each column.
  21. The ALTER TABLE statement specifies whether a column should be ____ or deleted in a table in Oracle.
  22. The application manages CPU allocations on a database instance server using an instance ____ approach.
  23. The main difference between temporary tables and ordinary tables is that temporary tables cannot have ____ keys related to other tables
  24. The schema owned by a table is specified by what?
  25. The _____ and block types are all available to temporary tables.
  26. Using performance optimization techniques in its database, we can reduce ____.
  27. Using ____ technology, it is possible to recover those data that have been improperly deleted or lost due to human error. These include data that has been accidentally deleted, data that has been deleted in error, or data that has been dropped.
  28. What is the statement to drop a column in the table?
  29. What is the statement to rename a column in the table?
  30. What is the syntax of creating global temporary tables?
  31. What is the syntax to add column in the table?
  32. What is the syntax to create a table?
  33. What is the syntax to declare the local temporary tables?
  34. What is the value of the column by default, if the value is left blank? NULL
  35. What is/are the disadvantage(s) of Oracle Database?
  36. What is/are the parameter(s) in DROP TABLE?
  37. What the column must have while creation?
  38. While creating table, the column should be specified as ____.
  39. With Oracle database, data is managed in an ____ manner (1).
  40. With this database, you can easily write an Oracle application in a secure manner without having to make changes to your ____.
  41. With ____, the table and all its dependent objects are removed from the database and are not recoverable.
  42. You can drop a table from the Oracle database by using the ____ statement.
  43. ___ temporary tables in Oracle are distinct from temporary tables within modules.
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!